USE [totem]
GO

/****** Object:  StoredProcedure [dbo].[DatosPlantilla]    Script Date: 06/29/2012 07:24:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE procedure [dbo].[DatosPlantilla]
as 
begin
select p.NOMBRE as nombre, tp.NOMBRE_TP as tipo, ID_PLANTILLA as id from plantilla p, TIPO_PLANTILLA tp where p.ID_TP=tp.ID_TP order by tp.ID_TP
end
GO

